﻿CREATE TABLE [dbo].[Store_ProductImage] (
    [Id]               INT             IDENTITY (1, 1) NOT NULL,
    [Title]            NVARCHAR (1024) NULL,
    [Description]      TEXT            NULL,
    [CreationDate]     DATETIME        CONSTRAINT [DF_Store_ProductImage_CreationDate] DEFAULT (getdate()) NOT NULL,
    [FullImgLink]      NVARCHAR (4000) NOT NULL,
    [SmallImgLink]     NVARCHAR (4000) NOT NULL,
    [Store_Product_Id] INT             NOT NULL,
    CONSTRAINT [PK_Store_ProductImage] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Store_ProductImage_Store_Product] FOREIGN KEY ([Store_Product_Id]) REFERENCES [dbo].[Store_Product] ([Id])
);

